import openpyxl as xl

source_file = "/Users/frank/git/py_practice/source.xlsx"
source_sheet_name = "sheet1"
target_file = "/Users/frank/git/py_practice/target.xlsx"

def copy_sheet(source, target):
    max_row = source.max_row
    max_column = source.max_column
    for row in range(1, max_row + 1):
        for column in range(1, max_column + 1):
            print source.cell(row, column).value
            target.cell(row, column).value = source.cell(row, column).value
            # target.cell(row, column).base_date = source.cell(row, column).base_date
            # target.cell(row, column).comment = source.cell(row, column).comment
            # target.cell(row, column).has_style = source.cell(row, column).has_style
            # target.cell(row, column).style_id  = source.cell(row, column).style_id



if __name__=="__main__":
    source_wb = xl.load_workbook(source_file)
    target_wb = xl.Workbook()
    target = target_wb.create_sheet(source_sheet_name, 1)
    copy_sheet(source_wb.get_sheet_by_name(source_sheet_name), target)
    target_wb.save(target_file)
    
    
